using FarPoint.Win.Spread;
using FarPoint.Win.Spread.CellType;
using System;
using System.Drawing;

namespace Spread.Sparkline.Features
{
    public partial class MonthSparkline : Spread.Common.Features.Sample.BaseSampleControl
    {
        private Random _rand;

        public MonthSparkline()
        {
            InitializeComponent();
            Name = "Month";
            _rand = new Random();
            InitNormalSheet(_fpSpread.Sheets[0]);
            InitColorRangeSheet(_fpSpread.Sheets[1]);
        }

        #region Private Methods
        private void InitColorRangeSheet(SheetView sheetView)
        {
            var worksheet = sheetView.AsWorksheet();
            worksheet.Name = "ColorRange";

            worksheet.Cells["A1"].Text = "January";
            worksheet.Cells["B1"].Text = "Value";
            worksheet.Cells["C1"].Text = "Color";

            worksheet.Cells["E1"].Text = "February";
            worksheet.Cells["F1"].Text = "Value";
            worksheet.Cells["G1"].Text = "Color";

            worksheet.Cells["I1"].Text = "Diagram";

            worksheet.Columns["A"].ColumnWidth = 80;
            worksheet.Columns["B"].ColumnWidth = 70;
            worksheet.Columns["C"].ColumnWidth = 70;
            worksheet.Columns["D"].ColumnWidth = 30;
            worksheet.Columns["E"].ColumnWidth = 80;
            worksheet.Columns["F"].ColumnWidth = 70;
            worksheet.Columns["G"].ColumnWidth = 70;
            worksheet.Columns["H"].ColumnWidth = 30;
            worksheet.Columns["I"].ColumnWidth = 90;

            sheetView.Cells["A1:I1"].BackColor = ColorTranslator.FromHtml("#999999");
            sheetView.Cells["A1:I1"].ForeColor = ColorTranslator.FromHtml("#FFFFFF");

            var dateCellType = new DateTimeCellType()
            {
                DateTimeFormat = DateTimeFormat.UserDefined,
                UserDefinedFormat = "yyyy-MM-dd"
            };

            worksheet.Cells["A2:A32"].CellType = dateCellType;
            worksheet.Cells["E2:E29"].CellType = dateCellType;

            worksheet.Cells["I3:I7"].Merge();
            worksheet.Cells["I10:I14"].Merge();

            DateTime date = new DateTime(2020, 1, 1);
            for (int row = 1; row <= 31; row++)
            {
                worksheet.Cells[$"A{row + 1}"].Value = date.AddDays(row - 1);
                worksheet.Cells[$"B{row + 1}"].Value = Math.Round(_rand.NextDouble() * 100);
                worksheet.Cells[$"C{row + 1}"].Value = GetRandomColor();
            }

            date = new DateTime(2020, 2, 1);
            for (int row = 1; row <= 28; row++)
            {
                worksheet.Cells[$"E{row + 1}"].Value = date.AddDays(row - 1);
                worksheet.Cells[$"F{row + 1}"].Value = Math.Round(_rand.NextDouble() * 100);
                worksheet.Cells[$"G{row + 1}"].Value = GetRandomColor();
            }

            worksheet.Cells["I3"].Formula2 = "MONTHSPARKLINE(2020,1,A2:B31,C2:C32)";
            worksheet.Cells["I8"].Formula2 = "TEXT(DATE(2020,1, 1),\"mmmm\")";

            worksheet.Cells["I10"].Formula2 = "MONTHSPARKLINE(2020,2,E2:F29,G2:G29)";
            worksheet.Cells["I15"].Formula2 = "TEXT(DATE(2020,2, 1),\"mmmm\")";
        }

        private void InitNormalSheet(SheetView sheetView)
        {
            var worksheet = sheetView.AsWorksheet();
            worksheet.Name = "No ColorRange";
            worksheet.Cells["A1"].Text = "January";
            worksheet.Cells["B1"].Text = "Value";

            worksheet.Cells["D1"].Text = "February";
            worksheet.Cells["E1"].Text = "Value";

            worksheet.Cells["G1"].Text = "Diagram";

            worksheet.Columns["A"].ColumnWidth = 80;
            worksheet.Columns["B"].ColumnWidth = 70;
            worksheet.Columns["C"].ColumnWidth = 30;
            worksheet.Columns["D"].ColumnWidth = 80;
            worksheet.Columns["E"].ColumnWidth = 70;
            worksheet.Columns["F"].ColumnWidth = 30;
            worksheet.Columns["G"].ColumnWidth = 90;

            sheetView.Cells["A1:G1"].BackColor = ColorTranslator.FromHtml("#999999");
            sheetView.Cells["A1:G1"].ForeColor = ColorTranslator.FromHtml("#FFFFFF");

            var dateCellType = new DateTimeCellType()
            {
                DateTimeFormat = DateTimeFormat.UserDefined,
                UserDefinedFormat = "yyyy-MM-dd"
            };

            worksheet.Cells["A2:A32"].CellType = dateCellType;
            worksheet.Cells["D2:D29"].CellType = dateCellType;

            worksheet.Cells["G3:G7"].Merge();
            worksheet.Cells["G10:G14"].Merge();

            DateTime date = new DateTime(2020, 1, 1);
            for (int row = 1; row <= 31; row++)
            {
                worksheet.Cells[$"A{row + 1}"].Value = date.AddDays(row - 1);
                worksheet.Cells[$"B{row + 1}"].Value = Math.Round(_rand.NextDouble() * 100);
            }

            date = new DateTime(2020, 2, 1);
            for (int row = 1; row <= 28; row++)
            {
                worksheet.Cells[$"D{row + 1}"].Value = date.AddDays(row - 1);
                worksheet.Cells[$"E{row + 1}"].Value = Math.Round(_rand.NextDouble() * 100);
            }

            worksheet.Cells["G3"].Formula2 = "MONTHSPARKLINE(2020, 1, A2:B32, \"#6d6d6d\", \"#c4c4c4\", \"#979797\", \"#f3f3f3\")";
            worksheet.Cells["G8"].Formula2 = "TEXT(DATE(2020,1, 1),\"mmmm\")";

            worksheet.Cells["G10"].Formula2 = "MONTHSPARKLINE(2020,2, D2:E29, \"#6d6d6d\", \"#c4c4c4\", \"#979797\", \"#f3f3f3\")";
            worksheet.Cells["G15"].Formula2 = "TEXT(DATE(2020,2, 1),\"mmmm\")";
        }

        private string GetRandomColor()
        {
            var colorList = new string[] { "#82bc00", "#9fc94c", "#00C2D6", "#d2e4a7", "#e9f2d2", "#ffedd3", "#ffdba8", "#ffc97d", "#feb850", "#f7a711", "#00c2d6" };
            return colorList[_rand.Next(0, colorList.Length)];
        }
        #endregion
    }
}


//
//MonthSparkline.Designer.cs
//



namespace Spread.Sparkline.Features
{
    partial class MonthSparkline
    {
        /// <summary> 
        /// Required designer variable.
        /// </summary>
        private System.ComponentModel.IContainer components = null;

        /// <summary> 
        /// Clean up any resources being used.
        /// </summary>
        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
        protected override void Dispose(bool disposing)
        {
            if (disposing && (components != null))
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }

        #region Component Designer generated code

        /// <summary> 
        /// Required method for Designer support - do not modify 
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(MonthSparkline));
            this._fpSpread = new FarPoint.Win.Spread.FpSpread(FarPoint.Win.Spread.LegacyBehaviors.None, ((object)(resources.GetObject("pnlMain.Controls"))));
            this._fpSpread_Sheet1 = this._fpSpread.GetSheet(0);
            this._fpSpread_Sheet2 = this._fpSpread.GetSheet(1);
            this.pnlMain.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this._fpSpread)).BeginInit();
            this.SuspendLayout();
            // 
            // pnlMain
            // 
            this.pnlMain.Controls.Add(this._fpSpread);
            // 
            // _fpSpread
            // 
            this._fpSpread.AccessibleDescription = "_fpSpread, Sheet1, Row 0, Column 0";
            this._fpSpread.Dock = System.Windows.Forms.DockStyle.Fill;
            this._fpSpread.Font = new System.Drawing.Font("Calibri", 11F);
            this._fpSpread.Location = new System.Drawing.Point(0, 0);
            this._fpSpread.Name = "_fpSpread";
            this._fpSpread.Size = new System.Drawing.Size(477, 487);
            this._fpSpread.TabIndex = 0;
            // 
            // MonthSparkline
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.Name = "MonthSparkline";
            this.pnlMain.ResumeLayout(false);
            ((System.ComponentModel.ISupportInitialize)(this._fpSpread)).EndInit();
            this.ResumeLayout(false);

        }

        #endregion

        private FarPoint.Win.Spread.FpSpread _fpSpread;
        private FarPoint.Win.Spread.SheetView _fpSpread_Sheet1;
        private FarPoint.Win.Spread.SheetView _fpSpread_Sheet2;
    }
}
